<?php
	define('CONFIG_FILE',true);
    include '../config.php';
    
	define('DB_FILE',true);
	require_once '../Tool/DB/SqlDBManager.class.php';

	$sqlDBManager = new SqlDBManager();

	session_start();
	if (empty($_SESSION["userType"])) {
		$url="../Index.php";
		include_once '../Tool/Common/Redirect.php';
		exit();
	}else{
		$userType = $_SESSION["userType"];
	}

	if (!empty($_SESSION["centreName"])) {
	    $centreName = $_SESSION["centreName"];
	}

	$page = isset($_POST['page']) ? intval($_POST['page']) : 1;
	$rows = isset($_POST['rows']) ? intval($_POST['rows']) : 10;
	$sort = isset($_POST['sort']) ? strval($_POST['sort']) : 'NRIC';
	$order = isset($_POST['order']) ? strval($_POST['order']) : 'asc';
	$searchid='';
	if(isset($_POST['searchid'])){
		$searchid = $_POST['searchid'];
	}
	$offset = ($page - 1) * $rows;
	$result = array();

	$sql ="select count(*) from client  where CentreId is null";

    $res=$sqlDBManager->queryRow($sql);

	if(!empty($res)){
		$result["total"] = $res[0];
	}
	else{
		$result["total"] = 0;
	}

	//Filter the $searchid
	$searchid=addslashes($searchid);
	$searchid=str_replace("%", "\%", $searchid);
	$searchid=str_replace("_", "\_", $searchid);

    $sql ="SELECT NRIC, CustomerName, Citizenship,Daycare, BeforeDeviation, AfterDeviation, DateOfBirth, Gender,  'Withdrawn' AS CentreName
		FROM client
		WHERE CentreId IS NULL AND (
		NRIC LIKE  ?
        OR CustomerName LIKE ?
		OR Citizenship LIKE  ?
		OR BeforeDeviation LIKE  ?
		OR AfterDeviation LIKE ?
		OR DateOfBirth LIKE ?
		OR Gender LIKE  ?
		) order by $sort $order limit $offset,$rows";
	
	$parameters = array("%".$searchid."%","%".$searchid."%","%".$searchid."%","%".$searchid."%","%".$searchid."%","%".$searchid."%","%".$searchid."%");

	$res=$sqlDBManager->queryRows($sql,$parameters);
	$item = array();
	
	if(!empty($res)){
		for($i=0;$i<count($res);$i++){
			array_push($item, $res[$i]);
		}	
	}
	
	//close connection
	$sqlDBManager->close_connect();

	$result["rows"] = $item;
	echo json_encode($result);
?>